Overview

Dataset statistics

Number of variables17
Number of observations4335
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory575.9 KiB
Average record size in memory136.0 B

Variable types

NUM11
CAT6

Reproduction

Analysis started2020-05-21 15:05:27.635943
Analysis finished2020-05-21 15:05:43.651956
Duration16.02 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

name has a high cardinality: 4166 distinct values High cardinality
host_name has a high cardinality: 909 distinct values High cardinality
last_review has a high cardinality: 763 distinct values High cardinality
id is highly correlated with df_indexHigh correlation
df_index is highly correlated with idHigh correlation
neighbourhood is highly correlated with neighbourhood_groupHigh correlation
neighbourhood_group is highly correlated with neighbourhoodHigh correlation
name is uniformly distributed Uniform
df_index has unique values Unique
id has unique values Unique

Variables

df_index
Real number (ℝ≥0)

HIGH CORRELATION
UNIQUE

Distinct count4335
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3605.105420991926
Minimum0
Maximum7767
Zeros1
Zeros (%)< 0.1%
Memory size33.9 KiB

Quantile statistics

Minimum0
5-th percentile293.7
Q11822.5
median3580
Q35349.5
95-th percentile7139.3
Maximum7767
Range7767
Interquartile range (IQR)3527

Descriptive statistics

Standard deviation2144.353152
Coefficient of variation (CV)0.59481011
Kurtosis-1.104769175
Mean3605.105421
Median Absolute Deviation (MAD)1763
Skewness0.07922266594
Sum15628132
Variance4598250.441
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
40941< 0.1%
 
67101< 0.1%
 
26441< 0.1%
 
46911< 0.1%
 
67341< 0.1%
 
46791< 0.1%
 
67261< 0.1%
 
5811< 0.1%
 
26281< 0.1%
 
46751< 0.1%
 
Other values (4325)432599.8%
 
ValueCountFrequency (%) 
01< 0.1%
 
11< 0.1%
 
21< 0.1%
 
31< 0.1%
 
41< 0.1%
 
ValueCountFrequency (%) 
77671< 0.1%
 
77661< 0.1%
 
77521< 0.1%
 
77281< 0.1%
 
77151< 0.1%
 

id
Real number (ℝ≥0)

HIGH CORRELATION
UNIQUE

Distinct count4335
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21990286.141868513
Minimum49091
Maximum37852422
Zeros0
Zeros (%)0.0%
Memory size33.9 KiB

Quantile statistics

Minimum49091
5-th percentile4449307.3
Q114838743
median23065902
Q330271830.5
95-th percentile35745370.3
Maximum37852422
Range37803331
Interquartile range (IQR)15433087.5

Descriptive statistics

Standard deviation9902633.473
Coefficient of variation (CV)0.4503185365
Kurtosis-0.9288682316
Mean21990286.14
Median Absolute Deviation (MAD)7578008
Skewness-0.3766415221
Sum9.532789042e+10
Variance9.806214969e+13
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
208650161< 0.1%
 
338133891< 0.1%
 
66280371< 0.1%
 
114654111< 0.1%
 
158702031< 0.1%
 
200407971< 0.1%
 
38632311< 0.1%
 
339196751< 0.1%
 
277941061< 0.1%
 
363793181< 0.1%
 
Other values (4325)432599.8%
 
ValueCountFrequency (%) 
490911< 0.1%
 
506461< 0.1%
 
563341< 0.1%
 
716091< 0.1%
 
718961< 0.1%
 
ValueCountFrequency (%) 
378524221< 0.1%
 
378412661< 0.1%
 
377987391< 0.1%
 
376905161< 0.1%
 
376216501< 0.1%
 

name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count4166
Unique (%)96.1%
Missing0
Missing (%)0.0%
Memory size33.9 KiB
Luxury hostel with in-cabin locker - Single mixed
 
9
Studio Apartment - Oakwood Premier
 
9
Superhost 1BR APT in the heart of Tg Pagar
 
8
Single Capsule For 1 (Free Breakfast)
 
7
Spacious bedroom near city centre with free Wi-Fi
 
6
Other values (4161)
4296
ValueCountFrequency (%) 
Luxury hostel with in-cabin locker - Single mixed90.2%
 
Studio Apartment - Oakwood Premier90.2%
 
Superhost 1BR APT in the heart of Tg Pagar80.2%
 
Single Capsule For 1 (Free Breakfast)70.2%
 
Spacious bedroom near city centre with free Wi-Fi60.1%
 
PROMO!! 1B Deluxe apartment perfect for Staycation50.1%
 
One Bedroom Deluxe Apartment - Oakwood Premier40.1%
 
NEW En-suite Bedroom /WIFI near Orchard/Somerset40.1%
 
Leisure 1BR APT located 5 mins from Tg Pagar MRT40.1%
 
Pleasant & Comfy Studio APT near Potong Pasir MRT40.1%
 
Other values (4156)427598.6%
 

Length

Max length85
Median length40
Mean length38.75847751
Min length1

host_id
Real number (ℝ≥0)

Distinct count1232
Unique (%)28.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean82279199.43183391
Minimum23666
Maximum282332472
Zeros0
Zeros (%)0.0%
Memory size33.9 KiB

Quantile statistics

Minimum23666
5-th percentile2413412
Q117526618
median47611818
Q3135756776
95-th percentile238891646
Maximum282332472
Range282308806
Interquartile range (IQR)118230158

Descriptive statistics

Standard deviation79283170.04
Coefficient of variation (CV)0.9635870377
Kurtosis-0.5047551364
Mean82279199.43
Median Absolute Deviation (MAD)39119811
Skewness0.8949660508
Sum3.566803295e+11
Variance6.285821052e+15
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
84920071333.1%
 
294208531172.7%
 
664061771062.4%
 
2413412811.9%
 
23722617781.8%
 
31464513711.6%
 
108773366641.5%
 
14521708631.5%
 
8948251521.2%
 
209913841491.1%
 
Other values (1222)352181.2%
 
ValueCountFrequency (%) 
236661< 0.1%
 
5949830.1%
 
1652092< 0.1%
 
1845961< 0.1%
 
2277961< 0.1%
 
ValueCountFrequency (%) 
2823324721< 0.1%
 
2823276511< 0.1%
 
2821203231< 0.1%
 
2820124861< 0.1%
 
2818985941< 0.1%
 

host_name
Categorical

HIGH CARDINALITY

Distinct count909
Unique (%)21.0%
Missing0
Missing (%)0.0%
Memory size33.9 KiB
Alvin
 
170
Aaron
 
117
Jay
 
115
Alex
 
89
Kaurus
 
81
Other values (904)
3763
ValueCountFrequency (%) 
Alvin1703.9%
 
Aaron1172.7%
 
Jay1152.7%
 
Alex892.1%
 
Kaurus811.9%
 
Darcy711.6%
 
RedDoorz641.5%
 
Shirley641.5%
 
Joey601.4%
 
Richards491.1%
 
Other values (899)345579.7%
 

Length

Max length35
Median length5
Mean length5.910495963
Min length1

neighbourhood_group
Categorical

HIGH CORRELATION

Distinct count5
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size33.9 KiB
Central Region
3563
East Region
 
266
West Region
 
257
North-East Region
 
160
North Region
 
89
ValueCountFrequency (%) 
Central Region356382.2%
 
East Region2666.1%
 
West Region2575.9%
 
North-East Region1603.7%
 
North Region892.1%
 

Length

Max length17
Median length14
Mean length13.7077278
Min length11

neighbourhood
Categorical

HIGH CORRELATION

Distinct count40
Unique (%)0.9%
Missing0
Missing (%)0.0%
Memory size33.9 KiB
Kallang
613
Geylang
580
Outram
 
308
Rochor
 
301
Novena
 
287
Other values (35)
2246
ValueCountFrequency (%) 
Kallang61314.1%
 
Geylang58013.4%
 
Outram3087.1%
 
Rochor3016.9%
 
Novena2876.6%
 
Downtown Core2355.4%
 
River Valley2315.3%
 
Bukit Merah2165.0%
 
Bedok2064.8%
 
Queenstown1152.7%
 
Other values (30)124328.7%
 

Length

Max length23
Median length7
Mean length8.287658593
Min length5

latitude
Real number (ℝ≥0)

Distinct count3117
Unique (%)71.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.3124298108419838
Minimum1.24526
Maximum1.45203
Zeros0
Zeros (%)0.0%
Memory size33.9 KiB

Quantile statistics

Minimum1.24526
5-th percentile1.279557
Q11.295815
median1.31038
Q31.318845
95-th percentile1.370646
Maximum1.45203
Range0.20677
Interquartile range (IQR)0.02303

Descriptive statistics

Standard deviation0.02843622
Coefficient of variation (CV)0.02166685012
Kurtosis5.114935631
Mean1.312429811
Median Absolute Deviation (MAD)0.01222
Skewness1.878096428
Sum5689.38323
Variance0.0008086186079
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1.2837670.2%
 
1.3144360.1%
 
1.3113760.1%
 
1.3131450.1%
 
1.3140850.1%
 
1.2948850.1%
 
1.3137250.1%
 
1.3035250.1%
 
1.314550.1%
 
1.314350.1%
 
Other values (3107)428198.8%
 
ValueCountFrequency (%) 
1.245261< 0.1%
 
1.248531< 0.1%
 
1.264781< 0.1%
 
1.265131< 0.1%
 
1.265691< 0.1%
 
ValueCountFrequency (%) 
1.452031< 0.1%
 
1.449681< 0.1%
 
1.449281< 0.1%
 
1.448611< 0.1%
 
1.448431< 0.1%
 

longitude
Real number (ℝ≥0)

Distinct count3387
Unique (%)78.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean103.85037353633217
Minimum103.66547
Maximum103.97341999999999
Zeros0
Zeros (%)0.0%
Memory size33.9 KiB

Quantile statistics

Minimum103.66547
5-th percentile103.764189
Q1103.83847
median103.85024
Q3103.875515
95-th percentile103.9118
Maximum103.97342
Range0.30795
Interquartile range (IQR)0.037045

Descriptive statistics

Standard deviation0.04205745333
Coefficient of variation (CV)0.0004049812427
Kurtosis2.499454124
Mean103.8503735
Median Absolute Deviation (MAD)0.0138
Skewness-0.8255072814
Sum450191.3693
Variance0.001768829381
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
103.8878850.1%
 
103.8453650.1%
 
103.8401450.1%
 
103.8386350.1%
 
103.8479450.1%
 
103.843650.1%
 
103.8519250.1%
 
103.8469140.1%
 
103.8520740.1%
 
103.8429640.1%
 
Other values (3377)428898.9%
 
ValueCountFrequency (%) 
103.665471< 0.1%
 
103.686761< 0.1%
 
103.687441< 0.1%
 
103.687791< 0.1%
 
103.687821< 0.1%
 
ValueCountFrequency (%) 
103.973421< 0.1%
 
103.972921< 0.1%
 
103.971051< 0.1%
 
103.968151< 0.1%
 
103.967391< 0.1%
 

room_type
Categorical

Distinct count3
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size33.9 KiB
Entire home/apt
2281
Private room
1796
Shared room
 
258
ValueCountFrequency (%) 
Entire home/apt228152.6%
 
Private room179641.4%
 
Shared room2586.0%
 

Length

Max length15
Median length15
Mean length13.51903114
Min length11

price
Real number (ℝ≥0)

Distinct count290
Unique (%)6.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean149.0701268742791
Minimum14
Maximum999
Zeros0
Zeros (%)0.0%
Memory size33.9 KiB

Quantile statistics

Minimum14
5-th percentile35
Q165
median119
Q3199
95-th percentile368
Maximum999
Range985
Interquartile range (IQR)134

Descriptive statistics

Standard deviation116.0404973
Coefficient of variation (CV)0.7784289164
Kurtosis6.918869806
Mean149.0701269
Median Absolute Deviation (MAD)59
Skewness2.094410009
Sum646219
Variance13465.39702
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
601232.8%
 
501092.5%
 
100982.3%
 
119892.1%
 
200892.1%
 
90862.0%
 
56841.9%
 
150841.9%
 
131821.9%
 
69811.9%
 
Other values (280)341078.7%
 
ValueCountFrequency (%) 
141< 0.1%
 
182< 0.1%
 
19170.4%
 
2140.1%
 
22170.4%
 
ValueCountFrequency (%) 
9992< 0.1%
 
9001< 0.1%
 
8871< 0.1%
 
8811< 0.1%
 
8441< 0.1%
 

minimum_nights
Real number (ℝ≥0)

Distinct count49
Unique (%)1.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.011534025374855
Minimum1
Maximum700
Zeros0
Zeros (%)0.0%
Memory size33.9 KiB

Quantile statistics

Minimum1
5-th percentile1
Q11
median3
Q37
95-th percentile90
Maximum700
Range699
Interquartile range (IQR)6

Descriptive statistics

Standard deviation32.24885722
Coefficient of variation (CV)2.478482334
Kurtosis78.35121349
Mean13.01153403
Median Absolute Deviation (MAD)2
Skewness6.563165133
Sum56405
Variance1039.988792
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1116426.9%
 
293221.5%
 
360313.9%
 
902395.5%
 
52285.3%
 
72124.9%
 
301754.0%
 
41423.3%
 
61333.1%
 
181082.5%
 
Other values (39)3999.2%
 
ValueCountFrequency (%) 
1116426.9%
 
293221.5%
 
360313.9%
 
41423.3%
 
52285.3%
 
ValueCountFrequency (%) 
7001< 0.1%
 
36570.2%
 
3561< 0.1%
 
1901< 0.1%
 
18330.1%
 

number_of_reviews
Real number (ℝ≥0)

Distinct count202
Unique (%)4.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21.128950403690887
Minimum1
Maximum323
Zeros0
Zeros (%)0.0%
Memory size33.9 KiB

Quantile statistics

Minimum1
5-th percentile1
Q12
median7
Q324
95-th percentile91.3
Maximum323
Range322
Interquartile range (IQR)22

Descriptive statistics

Standard deviation35.6465398
Coefficient of variation (CV)1.687094679
Kurtosis14.5780103
Mean21.1289504
Median Absolute Deviation (MAD)6
Skewness3.363946268
Sum91594
Variance1270.6758
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
186219.9%
 
245410.5%
 
32896.7%
 
42064.8%
 
51713.9%
 
61593.7%
 
71272.9%
 
81102.5%
 
91022.4%
 
11932.1%
 
Other values (192)176240.6%
 
ValueCountFrequency (%) 
186219.9%
 
245410.5%
 
32896.7%
 
42064.8%
 
51713.9%
 
ValueCountFrequency (%) 
3231< 0.1%
 
3071< 0.1%
 
2961< 0.1%
 
2911< 0.1%
 
2891< 0.1%
 

last_review
Categorical

HIGH CARDINALITY

Distinct count763
Unique (%)17.6%
Missing0
Missing (%)0.0%
Memory size33.9 KiB
2019-08-12
 
147
2019-08-11
 
122
2019-08-13
 
109
2019-08-10
 
84
2019-08-08
 
77
Other values (758)
3796
ValueCountFrequency (%) 
2019-08-121473.4%
 
2019-08-111222.8%
 
2019-08-131092.5%
 
2019-08-10841.9%
 
2019-08-08771.8%
 
2019-08-04711.6%
 
2019-08-25631.5%
 
2019-08-05621.4%
 
2019-07-29591.4%
 
2019-08-24591.4%
 
Other values (753)348280.3%
 

Length

Max length10
Median length10
Mean length10
Min length10

reviews_per_month
Real number (ℝ≥0)

Distinct count520
Unique (%)12.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.1483737024221454
Minimum0.01
Maximum13.0
Zeros0
Zeros (%)0.0%
Memory size33.9 KiB

Quantile statistics

Minimum0.01
5-th percentile0.07
Q10.23
median0.66
Q31.55
95-th percentile3.963
Maximum13
Range12.99
Interquartile range (IQR)1.32

Descriptive statistics

Standard deviation1.335390003
Coefficient of variation (CV)1.162853172
Kurtosis7.313129462
Mean1.148373702
Median Absolute Deviation (MAD)0.5
Skewness2.212140844
Sum4978.2
Variance1.783266459
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
11623.7%
 
0.12741.7%
 
0.08681.6%
 
0.14671.5%
 
0.16621.4%
 
0.15611.4%
 
0.1591.4%
 
0.06581.3%
 
0.07551.3%
 
0.17541.2%
 
Other values (510)361583.4%
 
ValueCountFrequency (%) 
0.012< 0.1%
 
0.02230.5%
 
0.03451.0%
 
0.04441.0%
 
0.05431.0%
 
ValueCountFrequency (%) 
131< 0.1%
 
12.61< 0.1%
 
121< 0.1%
 
11.031< 0.1%
 
8.371< 0.1%
 

calculated_host_listings_count
Real number (ℝ≥0)

Distinct count55
Unique (%)1.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean39.424452133794695
Minimum1
Maximum274
Zeros0
Zeros (%)0.0%
Memory size33.9 KiB

Quantile statistics

Minimum1
5-th percentile1
Q13
median12
Q345
95-th percentile203
Maximum274
Range273
Interquartile range (IQR)42

Descriptive statistics

Standard deviation61.09287529
Coefficient of variation (CV)1.549618878
Kurtosis4.451735451
Mean39.42445213
Median Absolute Deviation (MAD)10
Skewness2.184761119
Sum170905
Variance3732.339411
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
162614.4%
 
23929.0%
 
32114.9%
 
41453.3%
 
81423.3%
 
2031333.1%
 
51293.0%
 
71272.9%
 
61262.9%
 
141192.7%
 
Other values (45)218550.4%
 
ValueCountFrequency (%) 
162614.4%
 
23929.0%
 
32114.9%
 
41453.3%
 
51293.0%
 
ValueCountFrequency (%) 
2741062.4%
 
2031333.1%
 
157491.1%
 
1411172.7%
 
114711.6%
 

availability_365
Real number (ℝ≥0)

Distinct count355
Unique (%)8.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean238.48558246828142
Minimum1
Maximum365
Zeros0
Zeros (%)0.0%
Memory size33.9 KiB

Quantile statistics

Minimum1
5-th percentile34
Q1118
median292
Q3353
95-th percentile365
Maximum365
Range364
Interquartile range (IQR)235

Descriptive statistics

Standard deviation123.401892
Coefficient of variation (CV)0.5174396321
Kurtosis-1.319390867
Mean238.4855825
Median Absolute Deviation (MAD)71
Skewness-0.5223164462
Sum1033835
Variance15228.02696
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3653367.8%
 
3641272.9%
 
362892.1%
 
359882.0%
 
358841.9%
 
363641.5%
 
356641.5%
 
361631.5%
 
360621.4%
 
351410.9%
 
Other values (345)331776.5%
 
ValueCountFrequency (%) 
1100.2%
 
2150.3%
 
3130.3%
 
470.2%
 
570.2%
 
ValueCountFrequency (%) 
3653367.8%
 
3641272.9%
 
363641.5%
 
362892.1%
 
361631.5%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

Sample

First rows

df_indexidnamehost_idhost_nameneighbourhood_groupneighbourhoodlatitudelongituderoom_typepriceminimum_nightsnumber_of_reviewslast_reviewreviews_per_monthcalculated_host_listings_countavailability_365
0049091COZICOMFORT LONG TERM STAY ROOM 2266763FrancescaNorth RegionWoodlands1.44255103.79580Private room8318012013-10-210.012365
1150646Pleasant Room along Bukit Timah227796SujathaCentral RegionBukit Timah1.33235103.78521Private room8190182014-12-260.281365
2256334COZICOMFORT266763FrancescaNorth RegionWoodlands1.44246103.79667Private room696202015-10-010.202365
3371609Ensuite Room (Room 1 & 2) near EXPO367042BelindaEast RegionTampines1.34541103.95712Private room2061142019-08-110.159353
4471896B&B Room 1 near Airport & EXPO367042BelindaEast RegionTampines1.34567103.95963Private room941222019-07-280.229355
5571903Room 2-near Airport & EXPO367042BelindaEast RegionTampines1.34702103.96103Private room1041392019-08-150.389346
66719073rd level Jumbo room 5 near EXPO367042BelindaEast RegionTampines1.34348103.96337Private room2081252019-07-250.259172
77241503Long stay at The Breezy East "Leopard"1017645BiancaEast RegionBedok1.32304103.91363Private room50901742019-05-311.88459
88241508Long stay at The Breezy East "Plumeria"1017645BiancaEast RegionBedok1.32458103.91163Private room54901982019-04-282.084133
99241510Long stay at The Breezy East "Red Palm"1017645BiancaEast RegionBedok1.32461103.91191Private room42902362019-07-312.534147

Last rows

df_indexidnamehost_idhost_nameneighbourhood_groupneighbourhoodlatitudelongituderoom_typepriceminimum_nightsnumber_of_reviewslast_reviewreviews_per_monthcalculated_host_listings_countavailability_365
4325769737554967Single Bed in 6 Bed Female Dorm87731750Gap YearCentral RegionKallang1.31605103.85961Shared room25112019-08-121.08198
4326769837576690Single Bed in 4 Bed Mixed Dorm87731750Gap YearCentral RegionKallang1.31475103.85874Shared room26112019-08-101.08189
4327769937577304Private stylish room with ensuite bathroom8600508HelenCentral RegionMarine Parade1.30171103.90113Private room169212019-08-141.01365
4328770637587133FULLY FURNISHED 3 BEDROOM, CLEMENTI238891646NehaWest RegionClementi1.31403103.75964Entire home/apt344312019-08-211.034364
4329771437619286Double Pod Capsule in Mixed Dorm87731750Gap YearCentral RegionKallang1.31505103.86022Shared room56112019-08-131.08121
4330771537621650Comfortable and spacious four-bedroom family suite43591543DonaldCentral RegionGeylang1.31410103.90317Entire home/apt699362019-08-236.015189
4331772837690516cozy Condominium in quite neighbourhoods165475492BOONCheanCentral RegionToa Payoh1.34063103.88219Private room60112019-08-121.011
4332775237798739near Clementi MRT female only157856583ElyssaWest RegionClementi1.30677103.76224Private room56112019-08-171.01120
4333776637841266Sunny Modern Condo in City Center walk to MRT39207304SophieCentral RegionRochor1.30074103.84742Entire home/apt237712019-08-251.012159
4334776737852422Private Room With King Size Bed Near Seng Kang MRT119880789ChristineNorth-East RegionSengkang1.39324103.89002Private room60112019-08-251.01298